2015-04-20 - 16720.600 - Spec - Direct Ship from Derby #CrystalReportDevelopment
SPECIFICATIONS
16720.600 - Direct Ship from Derby
Purpose
Need to create two new reports INV700 and INV710 to get the visibility to inventory added and inventory to scrap.
Admin Info
Purpose
|
Need to get the visibility to inventory added and inventory to scrap
|
Requested By
|
Kevin Boleware
|
Spec Created By
|
Venkateswara Reddy D
|
Spec Created Date
|
04/20/2015
|
Spec QA by
|
Uday Kumar P
|
Objects
|
VBEP,VBAP,CAUFV,J_3ABSSI,MSEG
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
24
|
2
|
Documentation
|
08
|
3
|
Development/ Config
|
50
|
4
|
Unit test in DEV
|
15
|
5
|
Unit test in QUA
|
15
|
6
|
Other activity
|
08
|
|
TOTAL
|
120
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1
|
Need to change the Movement type '561' with 'ZD1' and '551' with 'ZD3' in INV710 report.
|
Babu Lankipalli
|
04/28/2015
|
|
2
|
Need to update the INV710 report in production version
|
Babu Lankipalli
|
05/04/2015
|
|
3
|
Need to update the INV700 report in quality version
|
Babu Lankipalli
|
05/26/2015
|
|
Functional Requirement
Purpose/WHY:
Need to create two new reports INV700 and INV710 for get the visibility to inventory added and inventory to scrap.
In Scope:
INV700 and INV710
Out of Scope:
Other Inventory Reports.
Solution Summary
INV700 - Direct Shipment Sales Order Inventory:
1. Established the link between the tables:
i) CAUFV -> J_3ABSSI
ii) J_3ABSSI -> VBEP.
2. Created three input parameters.
3. Filter the data based on the input parameters.
INV710 - Direct Shipment Inventory Reconciliation:
1. Established the link between the tables:
i) VBEP -> VBAP
ii) VBEP -> MSEG
iii) VBEP -> J3ABSSI.
2. Created an input parameter sales order(VBEP-VBELN) to filter the data.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Solution Details
INV700 - Direct Shipment Sales Order Inventory:
1. Need to establish link between the tables:
i) CAUFV -> J_3ABSSI
ii) J_3ABSSI -> VBEP.
2. Need to create three input parameters to filter the data:
i) Sales order
ii) Schedule start date
iii) Schedule finish date.
3. Need to develop the filter condition to get the required information.
INV710 - Direct Shipment Inventory Reconciliation:
1. Need to establish link between the tables:
i) VBEP -> VBAP
ii) VBEP -> MSEG
iii) VBEP -> J3ABSSI.
2. Need to create input parameter for sales order(VBEP-VBELN) to filter the data.
3. Need to develop the formula to remove the leading zeros.
4. Need to create the groups to remove the duplicates.
Issues
None